INSERT INTO [digitwhu].[dbo].[path]
           ([street_id]
           ,[node_id]
           ,[type]
           ,[north]
           ,[south]
           ,[west]
           ,[east])
     VALUES
(NULL,6,'s',NULL,15,NULL,NULL),
(NULL,6,'cross',NULL,NULL,NULL,NULL),
(NULL,15,'ns',6,24,NULL,NULL),
(NULL,23,'e',NULL,NULL,NULL,24),
(NULL,23,'cross',NULL,NULL,NULL,NULL),
(NULL,24,'n',15,NULL,NULL,NULL),
(NULL,24,'s',NULL,33,NULL,NULL),
(NULL,24,'w',NULL,NULL,23,NULL),
(NULL,24,'cross',NULL,NULL,NULL,NULL),
(NULL,29,'n',20,NULL,NULL,NULL),
(NULL,29,'s',NULL,38,NULL,NULL),
(NULL,29,'e',NULL,NULL,NULL,30),
(NULL,29,'cross',NULL,NULL,NULL,NULL),
(NULL,30,'n',21,NULL,NULL,NULL),
(NULL,30,'s',NULL,39,NULL,NULL),
(NULL,30,'w',NULL,NULL,29,NULL),
(NULL,30,'e',NULL,NULL,NULL,31),
(NULL,30,'cross',NULL,NULL,NULL,NULL),
(NULL,31,'n',22,NULL,NULL,NULL),
(NULL,31,'s',NULL,40,NULL,NULL),
(NULL,31,'w',NULL,NULL,30,NULL),
(NULL,31,'cross',NULL,NULL,NULL,NULL),
(NULL,33,'ns',24,42,NULL,NULL),
(NULL,37,'s',NULL,46,NULL,NULL),
(NULL,37,'cross',NULL,NULL,NULL,NULL),
(NULL,38,'ns',29,47,NULL,NULL),
(NULL,39,'ns',30,48,NULL,NULL),
(NULL,40,'ns',31,49,NULL,NULL),
(NULL,42,'ns',33,51,NULL,NULL),
(NULL,45,'e',NULL,NULL,NULL,46),
(NULL,45,'cross',NULL,NULL,NULL,NULL),
(NULL,46,'n',37,NULL,NULL,NULL),
(NULL,46,'s',NULL,55,NULL,NULL),
(NULL,46,'w',NULL,NULL,45,NULL),
(NULL,46,'e',NULL,NULL,NULL,47),
(NULL,46,'cross',NULL,NULL,NULL,NULL),
(NULL,47,'n',38,NULL,NULL,NULL),
(NULL,47,'w',NULL,NULL,46,NULL),
(NULL,47,'e',NULL,NULL,NULL,48),
(NULL,47,'cross',NULL,NULL,NULL,NULL),
(NULL,48,'n',39,NULL,NULL,NULL),
(NULL,48,'w',NULL,NULL,47,NULL),
(NULL,48,'e',NULL,NULL,NULL,49),
(NULL,48,'cross',NULL,NULL,NULL,NULL),
(NULL,49,'n',40,NULL,NULL,NULL),
(NULL,49,'s',NULL,58,NULL,NULL),
(NULL,49,'w',NULL,NULL,48,NULL),
(NULL,49,'e',NULL,NULL,NULL,50),
(NULL,49,'cross',NULL,NULL,NULL,NULL),
(NULL,50,'we',NULL,NULL,49,51),
(NULL,51,'n',42,NULL,NULL,NULL),
(NULL,51,'w',NULL,NULL,50,NULL),
(NULL,51,'cross',NULL,NULL,NULL,NULL),
(NULL,55,'n',46,NULL,NULL,NULL),
(NULL,55,'s',NULL,64,NULL,NULL),
(NULL,55,'e',NULL,NULL,NULL,56),
(NULL,55,'cross',NULL,NULL,NULL,NULL),
(NULL,56,'s',NULL,65,NULL,NULL),
(NULL,56,'w',NULL,NULL,55,NULL),
(NULL,56,'e',NULL,NULL,NULL,57),
(NULL,56,'cross',NULL,NULL,NULL,NULL),
(NULL,57,'we',NULL,NULL,56,58),
(NULL,58,'n',49,NULL,NULL,NULL),
(NULL,58,'w',NULL,NULL,57,NULL),
(NULL,58,'e',NULL,NULL,NULL,59),
(NULL,58,'cross',NULL,NULL,NULL,NULL),
(NULL,59,'we',NULL,NULL,58,60),
(NULL,60,'w',NULL,NULL,59,NULL),
(NULL,60,'cross',NULL,NULL,NULL,NULL),
(NULL,64,'ns',55,73,NULL,NULL),
(NULL,65,'ns',56,74,NULL,NULL),
(NULL,66,'s',NULL,75,NULL,NULL),
(NULL,66,'e',NULL,NULL,NULL,67),
(NULL,66,'cross',NULL,NULL,NULL,NULL),
(NULL,73,'ns',64,82,NULL,NULL),
(NULL,74,'n',65,NULL,NULL,NULL),
(NULL,74,'s',NULL,83,NULL,NULL),
(NULL,74,'e',NULL,NULL,NULL,75),
(NULL,74,'cross',NULL,NULL,NULL,NULL),
(NULL,75,'n',66,NULL,NULL,NULL),
(NULL,75,'w',NULL,NULL,74,NULL),
(NULL,75,'e',NULL,NULL,NULL,76),
(NULL,75,'cross',NULL,NULL,NULL,NULL),
(NULL,76,'we',NULL,NULL,75,77),
(NULL,77,'n',68,NULL,NULL,NULL),
(NULL,77,'s',NULL,86,NULL,NULL),
(NULL,77,'w',NULL,NULL,76,NULL),
(NULL,77,'e',NULL,NULL,NULL,78),
(NULL,77,'cross',NULL,NULL,NULL,NULL),
(NULL,78,'we',NULL,NULL,77,79),
(NULL,79,'n',70,NULL,NULL,NULL),
(NULL,79,'s',NULL,88,NULL,NULL),
(NULL,79,'w',NULL,NULL,78,NULL),
(NULL,79,'e',NULL,NULL,NULL,80),
(NULL,79,'cross',NULL,NULL,NULL,NULL),
(NULL,82,'n',73,NULL,NULL,NULL),
(NULL,82,'s',NULL,91,NULL,NULL),
(NULL,82,'e',NULL,NULL,NULL,83),
(NULL,82,'cross',NULL,NULL,NULL,NULL),
(NULL,83,'n',74,NULL,NULL,NULL),
(NULL,83,'s',NULL,92,NULL,NULL),
(NULL,83,'w',NULL,NULL,82,NULL),
(NULL,83,'e',NULL,NULL,NULL,84),
(NULL,83,'cross',NULL,NULL,NULL,NULL),
(NULL,84,'s',NULL,93,NULL,NULL),
(NULL,84,'w',NULL,NULL,83,NULL),
(NULL,84,'e',NULL,NULL,NULL,85),
(NULL,84,'cross',NULL,NULL,NULL,NULL),
(NULL,85,'we',NULL,NULL,84,86),
(NULL,86,'n',77,NULL,NULL,NULL),
(NULL,86,'s',NULL,95,NULL,NULL),
(NULL,86,'w',NULL,NULL,85,NULL),
(NULL,86,'cross',NULL,NULL,NULL,NULL),
(NULL,88,'ns',79,97,NULL,NULL),
(NULL,91,'ns',82,100,NULL,NULL),
(NULL,92,'ns',83,101,NULL,NULL),
(NULL,93,'n',84,NULL,NULL,NULL),
(NULL,93,'s',NULL,102,NULL,NULL),
(NULL,93,'e',NULL,NULL,NULL,94),
(NULL,93,'cross',NULL,NULL,NULL,NULL),
(NULL,94,'we',NULL,NULL,93,95),
(NULL,95,'n',86,NULL,NULL,NULL),
(NULL,95,'s',NULL,104,NULL,NULL),
(NULL,95,'w',NULL,NULL,94,NULL),
(NULL,95,'cross',NULL,NULL,NULL,NULL),
(NULL,97,'ns',88,106,NULL,NULL),
(NULL,100,'ns',91,109,NULL,NULL),
(NULL,101,'ns',92,110,NULL,NULL),
(NULL,102,'n',93,NULL,NULL,NULL),
(NULL,102,'s',NULL,111,NULL,NULL),
(NULL,102,'e',NULL,NULL,NULL,103),
(NULL,102,'cross',NULL,NULL,NULL,NULL),
(NULL,103,'we',NULL,NULL,102,104),
(NULL,104,'n',95,NULL,NULL,NULL),
(NULL,104,'s',NULL,113,NULL,NULL),
(NULL,104,'w',NULL,NULL,103,NULL),
(NULL,104,'cross',NULL,NULL,NULL,NULL),
(NULL,106,'ns',97,115,NULL,NULL),
(NULL,109,'ns',100,118,NULL,NULL),
(NULL,110,'ns',101,119,NULL,NULL),
(NULL,111,'ns',102,120,NULL,NULL),
(NULL,113,'n',104,NULL,NULL,NULL),
(NULL,113,'e',NULL,NULL,NULL,114),
(NULL,113,'cross',NULL,NULL,NULL,NULL),
(NULL,114,'we',NULL,NULL,113,115),
(NULL,115,'n',106,NULL,NULL,NULL),
(NULL,115,'w',NULL,NULL,114,NULL),
(NULL,115,'e',NULL,NULL,NULL,116),
(NULL,115,'cross',NULL,NULL,NULL,NULL),
(NULL,116,'s',NULL,125,NULL,NULL),
(NULL,116,'w',NULL,NULL,115,NULL),
(NULL,116,'cross',NULL,NULL,NULL,NULL),
(NULL,118,'n',109,NULL,NULL,NULL),
(NULL,118,'s',NULL,127,NULL,NULL),
(NULL,118,'e',NULL,NULL,NULL,119),
(NULL,118,'cross',NULL,NULL,NULL,NULL),
(NULL,119,'n',110,NULL,NULL,NULL),
(NULL,119,'w',NULL,NULL,118,NULL),
(NULL,119,'e',NULL,NULL,NULL,120),
(NULL,119,'cross',NULL,NULL,NULL,NULL),
(NULL,120,'n',111,NULL,NULL,NULL),
(NULL,120,'w',NULL,NULL,119,NULL),
(NULL,120,'e',NULL,NULL,NULL,121),
(NULL,120,'cross',NULL,NULL,NULL,NULL),
(NULL,121,'we',NULL,NULL,120,122),
(NULL,122,'we',NULL,NULL,121,123),
(NULL,123,'we',NULL,NULL,122,124),
(NULL,124,'we',NULL,NULL,123,125),
(NULL,125,'n',116,NULL,NULL,NULL),
(NULL,125,'w',NULL,NULL,124,NULL),
(NULL,125,'e',NULL,NULL,NULL,126),
(NULL,125,'cross',NULL,NULL,NULL,NULL),
(NULL,127,'ns',118,136,NULL,NULL),
(NULL,131,'s',NULL,140,NULL,NULL),
(NULL,131,'cross',NULL,NULL,NULL,NULL),
(NULL,136,'n',127,NULL,NULL,NULL),
(NULL,136,'s',NULL,145,NULL,NULL),
(NULL,136,'e',NULL,NULL,NULL,137),
(NULL,136,'cross',NULL,NULL,NULL,NULL),
(NULL,137,'we',NULL,NULL,136,138),
(NULL,138,'s',NULL,147,NULL,NULL),
(NULL,138,'w',NULL,NULL,137,NULL),
(NULL,138,'e',NULL,NULL,NULL,139),
(NULL,138,'cross',NULL,NULL,NULL,NULL),
(NULL,139,'s',NULL,148,NULL,NULL),
(NULL,139,'w',NULL,NULL,138,NULL),
(NULL,139,'e',NULL,NULL,NULL,140),
(NULL,139,'cross',NULL,NULL,NULL,NULL),
(NULL,140,'n',131,NULL,NULL,NULL),
(NULL,140,'w',NULL,NULL,139,NULL),
(NULL,140,'cross',NULL,NULL,NULL,NULL),
(NULL,145,'ns',136,154,NULL,NULL),
(NULL,147,'ns',138,156,NULL,NULL),
(NULL,148,'ns',139,157,NULL,NULL),
(NULL,153,'ns',144,162,NULL,NULL),
(NULL,154,'ns',145,163,NULL,NULL),
(NULL,155,'ns',146,164,NULL,NULL),
(NULL,156,'n',147,NULL,NULL,NULL),
(NULL,156,'s',NULL,165,NULL,NULL),
(NULL,156,'e',NULL,NULL,NULL,157),
(NULL,156,'cross',NULL,NULL,NULL,NULL),
(NULL,157,'n',148,NULL,NULL,NULL),
(NULL,157,'s',NULL,166,NULL,NULL),
(NULL,157,'w',NULL,NULL,156,NULL),
(NULL,157,'cross',NULL,NULL,NULL,NULL),
(NULL,162,'n',153,NULL,NULL,NULL),
(NULL,162,'e',NULL,NULL,NULL,163),
(NULL,162,'cross',NULL,NULL,NULL,NULL),
(NULL,163,'n',154,NULL,NULL,NULL),
(NULL,163,'s',NULL,172,NULL,NULL),
(NULL,163,'w',NULL,NULL,162,NULL),
(NULL,163,'e',NULL,NULL,NULL,164),
(NULL,163,'cross',NULL,NULL,NULL,NULL),
(NULL,164,'n',155,NULL,NULL,NULL),
(NULL,164,'w',NULL,NULL,163,NULL),
(NULL,164,'e',NULL,NULL,NULL,165),
(NULL,164,'cross',NULL,NULL,NULL,NULL),
(NULL,165,'n',156,NULL,NULL,NULL),
(NULL,165,'s',NULL,174,NULL,NULL),
(NULL,165,'w',NULL,NULL,164,NULL),
(NULL,165,'e',NULL,NULL,NULL,166),
(NULL,165,'cross',NULL,NULL,NULL,NULL),
(NULL,166,'n',157,NULL,NULL,NULL),
(NULL,166,'s',NULL,175,NULL,NULL),
(NULL,166,'w',NULL,NULL,165,NULL),
(NULL,166,'cross',NULL,NULL,NULL,NULL),
(NULL,172,'n',163,NULL,NULL,NULL),
(NULL,172,'s',NULL,181,NULL,NULL),
(NULL,172,'e',NULL,NULL,NULL,173),
(NULL,172,'cross',NULL,NULL,NULL,NULL),
(NULL,173,'s',NULL,182,NULL,NULL),
(NULL,173,'w',NULL,NULL,172,NULL),
(NULL,173,'e',NULL,NULL,NULL,174),
(NULL,173,'cross',NULL,NULL,NULL,NULL),
(NULL,174,'n',165,NULL,NULL,NULL),
(NULL,174,'s',NULL,183,NULL,NULL),
(NULL,174,'w',NULL,NULL,173,NULL),
(NULL,174,'e',NULL,NULL,NULL,175),
(NULL,174,'cross',NULL,NULL,NULL,NULL),
(NULL,175,'n',166,NULL,NULL,NULL),
(NULL,175,'s',NULL,184,NULL,NULL),
(NULL,175,'w',NULL,NULL,174,NULL),
(NULL,175,'cross',NULL,NULL,NULL,NULL),
(NULL,181,'n',172,NULL,NULL,NULL),
(NULL,181,'cross',NULL,NULL,NULL,NULL),
(NULL,182,'n',173,NULL,NULL,NULL),
(NULL,182,'cross',NULL,NULL,NULL,NULL),
(NULL,183,'n',174,NULL,NULL,NULL),
(NULL,183,'e',NULL,NULL,NULL,184),
(NULL,183,'cross',NULL,NULL,NULL,NULL),
(NULL,184,'n',175,NULL,NULL,NULL),
(NULL,184,'w',NULL,NULL,183,NULL),
(NULL,184,'cross',NULL,NULL,NULL,NULL)
GO
